Allocation script(Rule name : Allocate Opex) to allocate Parent level Opex based on prior year actual data

FIX ("Plan", "OFS_Load", "No Market", "No Product", "USD", "Sales US") 
    FIX ("FY25", @Relative("YearTotal", 0), @Relative("Total Travel and Entertainment Expense", 0)) 
        "Final" = ("Travel and Entertainment"->"Final" * "FY24"->"Actual"->"OEP_Working") / "FY24"->"Actual"->"OEP_Working"->"Total Travel and Entertainment Expense";
    ENDFIX 
    FIX ("FY25", @Relative("YearTotal", 0), @Relative("Total Marketing Expense", 0)) 
        "Final" = ("Marketing Expenses"->"Final" * "FY24"->"Actual"->"OEP_Working") / "FY24"->"Actual"->"OEP_Working"->"Total Marketing Expense";
    ENDFIX 
       FIX ("FY25", @Relative("YearTotal", 0), @Relative("Total Facilities Expenses", 0)) 
        "Final" = ("Facilities Expenses"->"Final" * "FY24"->"Actual"->"OEP_Working") / "FY24"->"Actual"->"OEP_Working"->"Total Facilities Expenses";
    ENDFIX 
    FIX ("FY25", @Relative("YearTotal", 0), @Relative("Total IT Spends", 0)) 
        "Final" = ("IT Spends"->"Final" * "FY24"->"Actual"->"OEP_Working") / "FY24"->"Actual"->"OEP_Working"->"Total IT Spends";
    ENDFIX 

    FIX ("FY25", @Relative("YearTotal", 0), @Relative("OFS_Total Other Expenses", 0)) 
        "Final" = ("Other Expenses"->"Final" * "FY24"->"Actual"->"OEP_Working") / "FY24"->"Actual"->"OEP_Working"->"OFS_Total Other Expenses";
    ENDFIX 
  
ENDFIX